package cn.itcast.mapper;

import cn.itcast.pojo.DegreeCount;
import cn.itcast.pojo.EmpJob;
import cn.itcast.pojo.Report;
import cn.itcast.pojo.StudentClazz;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface ReportMapper {
    //@Select("select gender name,count(*) value from emp group by gender")
    @MapKey("name")
    List<Map<String, Object>> empGenderData();

    @Select("select job jobList from emp group by job")
    List<String> empJobData();


    @Select("select count(*)  dataList from emp group by job")
    List<Integer> empCountData();

    @MapKey("jobName")
    List<Map<String, Object>> empCountDataPro();

    List<DegreeCount> studentDegreeData();

    @MapKey("name")
    List<Map<String, Object>> studentCountData();
}
